SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE [dbo].gspEmailTemplate_UPDATE
(
@templateId int = null,
@subject nvarchar(150) = null,
@content nvarchar(MAX) = null,
@templateType int = null,
@createDate datetime = null,
@lastModifiedDate datetime = null
)
AS

UPDATE
  [dbo].[EmailTemplate]
SET
  [Subject] = @subject,
  [Content] = @content,
  [TemplateType] = @templateType,
  [CreateDate] = @createDate,
  [LastModifiedDate] = @lastModifiedDate
WHERE
  [TemplateId] = @templateId

GO
